
      <?php require_once('inc_admin.php'); ?>

        <!--PAGE CONTENT -->
        <div id="content">

            <div class="inner" style="min-height:1200px;">
                <div class="row">
                    <div class="col-lg-12">


                        <?php 
     require_once('inc_admin.php'); 
    connect();
    //编写SQL语言
    $sql='select uid,uname,gender,birthdate,hobby,degree,intro,pic from users';
    //echo $sql.'<br/>';
    $result=mysql_query($sql) or die('查询失败！'.mysql_error());
 ?> 
 <center><h2>用户列表</h2></center>
 <table align="center" class="table table-hover table-condensed">
    <tr class="success">
        <th>用户编号</th>
        <th>用户名</th>
        <th>性别</th>
        <th>生日</th>
        <th>爱好</th>
        <th>学历</th>
        <th>自我介绍</th>
        <th width='80'>头像</th>
        <th>操作</th>
    </tr>
    <?php
    while($row=mysql_fetch_assoc($result)){
        echo '<tr>';
        echo '<td>'.$row['uid'].'</td>';
        echo '<td>'.$row['uname'].'</td>';
        echo '<td>'.($row['gender']==0?'男':'女').'</td>';
        echo '<td>'.$row['birthdate'].'</td>';
        echo '<td>'.$row['hobby'].'</td>';
        switch ($row['degree']) {
            case '1':$dg="高中";break;
            case '2':$dg="大学";break;
            case '3':$dg="研究生";break;   
            case '4':$dg="博士生";break;   
            default: $dg="不知道";
                }
                echo '<td>'.$dg.'</td>';
                echo '<td>'.$row['intro'].'</td>';
                echo '<td align="center" ><img  class="img-circle" src='.UserPhotoPath.$row['pic'].' width=80 height=80  alt="无头像"></td>';
                echo '<td> <a href="userEditForm.php?id='.$row['uid'].'">修改</a>
                <a href="userDelete.php?id='.$row['uid'].'"onClick="return confirm(\'确定要删除吗？\');">删除</a></td>';

        echo '</tr>';
    } 
    echo '</table>';
    $totalrows=mysql_num_rows($result);
    echo "<table align='center'><tr><td>共有{$totalrows}名用户</td></tr></table>"; 
     ?>
 



                    </div>
                </div>

                <hr />




            </div>




        </div>
       <!--END PAGE CONTENT -->


    </div>

     <!--END MAIN WRAPPER -->

   <!-- FOOTER -->
    <div id="footer">
       
    </div>
    <!--END FOOTER -->
     <!-- GLOBAL SCRIPTS -->
    <script src="assets/plugins/jquery-2.0.3.min.js"></script>
     <script src="assets/plugins/bootstrap/js/bootstrap.min.js"></script>
    <script src="assets/plugins/modernizr-2.6.2-respond-1.1.0.min.js"></script>
    <!-- END GLOBAL SCRIPTS -->
